﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;


namespace BussinessLayer
{
    public class tblThamso_kqht
    {
        DataLayer.Data odata = new DataLayer.Data();
        public DataTable Select()
        {
            return odata.view_text("SELECT * FROM thamso_kqht WHERE thamso_id=(select max(thamso_id) from thamso_kqht)");
        }
        public void thamso_kqht(int t1, int t2, int t3, int t4, int d1, int d2, int d3, int d4)
        {
            SqlParameter[] sp = new SqlParameter[8];
            sp[0] = new SqlParameter("@t1", t1);
            sp[1] = new SqlParameter("@t2", t2);
            sp[2] = new SqlParameter("@t3", t3);
            sp[3] = new SqlParameter("@t4", t4);
            sp[4] = new SqlParameter("@d1", d1);
            sp[5] = new SqlParameter("@d2", d2);
            sp[6] = new SqlParameter("@d3", d3);
            sp[7] = new SqlParameter("@d4", d4);
            odata.proc_TS("tblThamso_kqht", sp);
        }
    }
}
